﻿CREATE VIEW [dbo].[vwCustomerProject]
AS
SELECT     dbo.CustomerProject.CustomerID, dbo.CustomerProject.ProjectID, dbo.Projects.Name, dbo.Projects.Description
FROM         dbo.CustomerProject INNER JOIN
                      dbo.Projects ON dbo.CustomerProject.ProjectID = dbo.Projects.ProjectID;

